UPDATE Statement

 Action

 Adds an updated record to an ISAM table, overwriting the current record.

 Syntax


  UPDATE #  filenumber%,  recordvariable


 Remarks

 The  UPDATE statement uses the following arguments.

-----------------------------------------------------------------------------
 Argument                                Description
 ----------------------------------------------------------------------------
  filenumber%                            The number used in the  OPEN
                                         statement to open the table.

  recordvariable                         A variable of the user-defined
                                         type  tabletype that was specified
                                         in the  OPEN statement. It is the
                                         record that will overwrite the
                                         current record.





  UPDATE replaces the current record with  recordvariable. It remains the
 current record.

 Use the  RETRIEVE statement to fetch the current record and place its data
 into  recordvariable. You can change the data in  recordvariable, then use
 the  UPDATE statement to update the current record with the changes you've
 made. Use  INSERT to add a record to a table without overwriting the current
 record.

 If the values passed to  recordvariable do not match the record strucure in
 the user-defined type, BASIC generates the error message Type Mismatch.The
 record structure includes the names and types of columns or fields.

 BASIC removes trailing spaces from strings used in an update.

 See Also

  INSERT;  RETRIEVE;  SEEKGT,  SEEKGE,  SEEKEQ

 Example

 See the programming example for the  SEEKGT,  SEEKGE, and  SEEKEQ
 statements, which uses the  UPDATE statement.